﻿CREATE TABLE [dbo].[MaterielTyp] (
    [Id]          UNIQUEIDENTIFIER NOT NULL,
    [ValId]       UNIQUEIDENTIFIER NOT NULL,
    [Skapad]      DATETIME         NOT NULL,
    [SkapadAv]    NVARCHAR (50)    NOT NULL,
    [Andrad]      DATETIME         NULL,
    [AndradAv]    NVARCHAR (50)    NULL,
    [Beskrivning] NVARCHAR (200)   NOT NULL,
    [VisaILista]  BIT              CONSTRAINT [DF__MaterielT__VisaI__65370702] DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_MaterielTyp] PRIMARY KEY CLUSTERED ([Id] ASC, [ValId] ASC)
);









